thank you flash fill that is exactly what I wanted. Spreadsheet content: City, State, Full State Name (incorrectly generated). Examples: Austin TX Texas, Salt Lake City UT Utah, Durham NC North Carolina, Columbus OH Oorth Carolina, Baton Rouge LA Lorth Carolina, Omaha NE North Carolina, New Orleans LA Lorth Carolina, Des Moines IA Iorth Carolina, S